<Attachment Control Name> Registry entry

Specifies restrictions for the attachment of external Parties records to a Registration so that only records valid for the time frame of the record can be attached.

Usage

This Registry entry can be assigned to users and groups:

Key	User	User	Group	Group
Key 1	User	User	Group	Group
Key 2	user	user	Default	Default
Key 3	Table	Table	Table	Table
Key 4	table	Default	table	Default
Key 5	Control
Key 6	column
Key 7	Attachment table
Value	column=value;column=value;...

where:

Control	is the name of a control (identified using Field Level Help). The name of the control is specified in Key 5 to cover situations where there are two attachment fields in a link grid control so that each column can have its own set of restrictions.
column	name of a column in Control.
Attachment table	almost invariably the Parties module (eparties), but not restricted to eparties.
column=value;column=value;...	is a semicolon separated list of column=value pairs. When column is a text column and an OR query is required, the value may contain the OR values separated by \n. When column is a date column, the following syntax may be applied: column=>={Module Column:NULL) This means that the column we are querying must have a value that is greater than or equal to the value that is present in the column in the registration module or it may be NULL (empty). Likewise <= (less than or equal to) may also be used.

Example

This entry specifies that when attaching a Parties record in the funeral home field in the Deaths module, the search in Parties should only look for records that are of type Funeral Director or Funeral Home and the end date for the period of activity for the funeral home must either be greater than the date of Death or empty and the start date for the period of activity for the funeral home must either be less than the date of death or empty:

Key	Setting
Key 1	Group
Key 2	Default
Key 3	Table
Key 4	edeaths
Key 5	AllDetFuneralHomeRbx
Key 6	FuneralHomeName
Key 7	eparties
Value	NamPartyType=Funeral Director\nFuneral Home;HisEndLatestDate=>={DeceasedDateOfDeath:NULL}; HisBeginEarliestDate=<={DeceasedDateOfDeath:NULL}